/*
 Navicat Premium Data Transfer

 Source Server         : riverbed-mssql
 Source Server Type    : SQL Server
 Source Server Version : 16004105
 Source Host           : 192.168.1.240:1433
 Source Catalog        : riverbed
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16004105
 File Encoding         : 65001

 Date: 11/03/2024 09:28:10
*/


-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dept]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_dept]
GO

CREATE TABLE [dbo].[sys_dept] (
  [id] bigint  NOT NULL,
  [name] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [parent_id] bigint  NOT NULL,
  [tree_path] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [sort] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [status] tinyint  NOT NULL,
  [deleted] tinyint  NULL,
  [create_time] datetime2(7)  NULL,
  [create_userid] bigint  NULL,
  [create_username] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [update_time] datetime2(7)  NULL,
  [update_userid] bigint  NULL,
  [update_username] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_dept] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父节点id',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'parent_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父节点id路径',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'tree_path'
GO

EXEC sp_addextendedproperty
'MS_Description', N'显示顺序',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'sort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态(1:正常;0:禁用)',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'逻辑删除标识(1:已删除;0:未删除)',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'create_userid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept',
'COLUMN', N'update_userid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门表',
'SCHEMA', N'dbo',
'TABLE', N'sys_dept'
GO


-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN TRANSACTION
GO

INSERT INTO [dbo].[sys_dept] ([id], [name], [parent_id], [tree_path], [sort], [status], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'1', N'有来技术', N'0', N'0', N'1', N'1', N'0', NULL, N'1', NULL, NULL, N'1', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([id], [name], [parent_id], [tree_path], [sort], [status], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'2', N'研发部门', N'1', N'0,1', N'1', N'1', N'0', NULL, N'2', NULL, N'2022-04-19 12:46:37.0000000', N'2', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([id], [name], [parent_id], [tree_path], [sort], [status], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'3', N'测试部门', N'1', N'0,1', N'1', N'1', N'0', NULL, N'2', NULL, N'2022-04-19 12:46:37.0000000', N'2', NULL)
GO

COMMIT
GO


-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dict]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_dict]
GO

CREATE TABLE [dbo].[sys_dict] (
  [id] bigint  NOT NULL,
  [type_code] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [name] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [value] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [sort] int  NULL,
  [status] tinyint  NULL,
  [defaulted] tinyint  NULL,
  [remark] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [update_time] datetime2(7)  NULL
)
GO

ALTER TABLE [dbo].[sys_dict] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典类型编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'type_code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典项名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典项值',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'value'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'sort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态(1:正常;0:禁用)',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否默认(1:是;0:否)',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'defaulted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典数据表',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict'
GO


-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN TRANSACTION
GO

INSERT INTO [dbo].[sys_dict] ([id], [type_code], [name], [value], [sort], [status], [defaulted], [remark], [create_time], [update_time]) VALUES (N'1', N'gender', N'男', N'1', N'1', N'1', N'0', NULL, N'2019-05-05 13:07:52.0000000', N'2022-06-12 23:20:39.0000000')
GO

INSERT INTO [dbo].[sys_dict] ([id], [type_code], [name], [value], [sort], [status], [defaulted], [remark], [create_time], [update_time]) VALUES (N'2', N'gender', N'女', N'2', N'2', N'1', N'0', NULL, N'2019-04-19 11:33:00.0000000', N'2019-07-02 14:23:05.0000000')
GO

INSERT INTO [dbo].[sys_dict] ([id], [type_code], [name], [value], [sort], [status], [defaulted], [remark], [create_time], [update_time]) VALUES (N'3', N'gender', N'未知', N'0', N'1', N'1', N'0', NULL, N'2020-10-17 08:09:31.0000000', N'2020-10-17 08:09:31.0000000')
GO

COMMIT
GO


-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dict_type]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_dict_type]
GO

CREATE TABLE [dbo].[sys_dict_type] (
  [id] bigint  NOT NULL,
  [name] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [code] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [status] tinyint  NULL,
  [remark] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [update_time] datetime2(7)  NULL
)
GO

ALTER TABLE [dbo].[sys_dict_type] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键 ',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_type',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'类型名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_type',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'类型编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_type',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态(0:正常;1:禁用)',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_type',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_type',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_type',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_type',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典类型表',
'SCHEMA', N'dbo',
'TABLE', N'sys_dict_type'
GO


-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN TRANSACTION
GO

INSERT INTO [dbo].[sys_dict_type] ([id], [name], [code], [status], [remark], [create_time], [update_time]) VALUES (N'1', N'性别', N'gender', N'1', NULL, N'2019-12-06 19:03:32.0000000', N'2022-06-12 16:21:28.0000000')
GO

COMMIT
GO


-- ----------------------------
-- Table structure for sys_employee
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_employee]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_employee]
GO

CREATE TABLE [dbo].[sys_employee] (
  [id] bigint  NOT NULL,
  [name] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [nickname] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [gender] tinyint  NULL,
  [dept_id] bigint  NULL,
  [avatar] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [mobile] nvarchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [status] tinyint  NULL,
  [email] nvarchar(128) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [deleted] tinyint  NULL,
  [create_time] datetime2(7)  NULL,
  [create_userid] bigint  NULL,
  [create_username] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [update_time] datetime2(7)  NULL,
  [update_userid] bigint  NULL,
  [update_username] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_employee] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户名',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'昵称',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'nickname'
GO

EXEC sp_addextendedproperty
'MS_Description', N'性别((1:男;2:女))',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'gender'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'dept_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户头像',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'avatar'
GO

EXEC sp_addextendedproperty
'MS_Description', N'联系方式',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'mobile'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户状态((1:在职;0:离职))',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户邮箱',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'email'
GO

EXEC sp_addextendedproperty
'MS_Description', N'逻辑删除标识(0:未删除;1:已删除)',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建用户id',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'create_userid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建用户名',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'create_username'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新用户id',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'update_userid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新用户名',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee',
'COLUMN', N'update_username'
GO

EXEC sp_addextendedproperty
'MS_Description', N'员工信息表',
'SCHEMA', N'dbo',
'TABLE', N'sys_employee'
GO


-- ----------------------------
-- Records of sys_employee
-- ----------------------------
BEGIN TRANSACTION
GO

INSERT INTO [dbo].[sys_employee] ([id], [name], [nickname], [gender], [dept_id], [avatar], [mobile], [status], [email], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'1', N'root', N'有来技术', N'0', NULL, N'https://oss.youlai.tech/youlai-boot/2023/05/16/811270ef31f548af9cffc026dfc3777b.gif', N'17621590365', N'1', N'youlaitech@163.com', N'0', NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_employee] ([id], [name], [nickname], [gender], [dept_id], [avatar], [mobile], [status], [email], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'2', N'admin', N'系统管理员', N'1', N'1', N'https://oss.youlai.tech/youlai-boot/2023/05/16/811270ef31f548af9cffc026dfc3777b.gif', N'17621210366', N'1', N'', N'0', N'2019-10-10 13:41:22.0000000', NULL, NULL, N'2022-07-31 12:39:30.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_employee] ([id], [name], [nickname], [gender], [dept_id], [avatar], [mobile], [status], [email], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'3', N'test', N'测试小用户', N'1', N'3', N'https://oss.youlai.tech/youlai-boot/2023/05/16/811270ef31f548af9cffc026dfc3777b.gif', N'17621210366', N'1', N'youlaitech@163.com', N'0', N'2021-06-05 01:31:29.0000000', NULL, NULL, N'2021-06-05 01:31:29.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_employee] ([id], [name], [nickname], [gender], [dept_id], [avatar], [mobile], [status], [email], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'287', N'123', N'123', N'1', N'1', N'', NULL, N'1', NULL, N'1', N'2023-05-21 14:11:19.0000000', NULL, NULL, N'2023-05-21 14:11:25.0000000', NULL, NULL)
GO

COMMIT
GO


-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_menu]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_menu]
GO

CREATE TABLE [dbo].[sys_menu] (
  [id] bigint  NOT NULL,
  [parent_id] bigint  NOT NULL,
  [tree_path] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [name] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [type] tinyint  NOT NULL,
  [path] nvarchar(128) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [component] nvarchar(128) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [perm] nvarchar(128) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [visible] tinyint  NOT NULL,
  [sort] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [icon] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [redirect] nvarchar(128) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [create_time] datetime2(7)  NULL,
  [update_time] datetime2(7)  NULL,
  [always_show] tinyint  NULL,
  [keep_alive] tinyint  NULL
)
GO

ALTER TABLE [dbo].[sys_menu] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'父菜单ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'parent_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父节点ID路径',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'tree_path'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单类型(1:菜单 2:目录 3:外链 4:页面控件)',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'路由路径(浏览器地址栏路径)',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'path'
GO

EXEC sp_addextendedproperty
'MS_Description', N'组件路径(vue页面完整路径，省略.vue后缀)',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'component'
GO

EXEC sp_addextendedproperty
'MS_Description', N'权限标识',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'perm'
GO

EXEC sp_addextendedproperty
'MS_Description', N'显示状态(1-显示;0-隐藏)',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'visible'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'sort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单图标',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'icon'
GO

EXEC sp_addextendedproperty
'MS_Description', N'跳转路径',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'redirect'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'【目录】只有一个子路由是否始终显示(1:是 0:否)',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'always_show'
GO

EXEC sp_addextendedproperty
'MS_Description', N'【菜单】是否开启页面缓存(1:是 0:否)',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'keep_alive'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单管理',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu'
GO


-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN TRANSACTION
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'1', N'0', N'0', N'系统管理', N'2', N'/system', N'Layout', NULL, N'1', N'1', N'system', N'/system/user', N'2021-08-28 09:12:21.0000000', N'2021-08-28 09:12:21.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'2', N'1', N'0,1', N'用户管理', N'1', N'user', N'system/user/index', NULL, N'1', N'1', N'user', NULL, N'2021-08-28 09:12:21.0000000', N'2021-08-28 09:12:21.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'3', N'1', N'0,1', N'角色管理', N'1', N'role', N'system/role/index', NULL, N'1', N'2', N'role', NULL, N'2021-08-28 09:12:21.0000000', N'2021-08-28 09:12:21.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'4', N'1', N'0,1', N'菜单管理', N'1', N'menu', N'system/menu/index', NULL, N'1', N'3', N'menu', NULL, N'2021-08-28 09:12:21.0000000', N'2021-08-28 09:12:21.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'5', N'1', N'0,1', N'部门管理', N'1', N'dept', N'system/dept/index', NULL, N'1', N'4', N'tree', NULL, N'2021-08-28 09:12:21.0000000', N'2021-08-28 09:12:21.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'6', N'1', N'0,1', N'字典管理', N'1', N'dict', N'system/dict/index', NULL, N'1', N'5', N'dict', NULL, N'2021-08-28 09:12:21.0000000', N'2021-08-28 09:12:21.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'20', N'0', N'0', N'多级菜单', N'2', N'/multi-level', N'Layout', NULL, N'1', N'9', N'cascader', N'/multi-level/multi-level1', N'2022-02-16 23:11:00.0000000', N'2022-02-16 23:11:00.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'21', N'20', N'0,20', N'菜单一级', N'1', N'multi-level1', N'demo/multi-level/level1', NULL, N'1', N'1', N'', N'/multi-level/multi-level2', N'2022-02-16 23:13:38.0000000', N'2022-02-16 23:13:38.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'22', N'21', N'0,20,21', N'菜单二级', N'1', N'multi-level2', N'demo/multi-level/children/level2', NULL, N'1', N'1', N'', N'/multi-level/multi-level2/multi-level3-1', N'2022-02-16 23:14:23.0000000', N'2022-02-16 23:14:23.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'23', N'22', N'0,20,21,22', N'菜单三级-1', N'1', N'multi-level3-1', N'demo/multi-level/children/children/level3-1', NULL, N'1', N'1', N'', N'', N'2022-02-16 23:14:51.0000000', N'2022-02-16 23:14:51.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'24', N'22', N'0,20,21,22', N'菜单三级-2', N'1', N'multi-level3-2', N'demo/multi-level/children/children/level3-2', NULL, N'1', N'2', N'', N'', N'2022-02-16 23:15:08.0000000', N'2022-02-16 23:15:08.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'26', N'0', N'0', N'平台文档', N'2', N'/doc', N'Layout', NULL, N'1', N'8', N'document', NULL, N'2022-02-17 22:51:20.0000000', N'2022-02-17 22:51:20.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'30', N'26', N'0,26', N'平台文档(外链)', N'3', N'https://juejin.cn/post/7228990409909108793', N'', NULL, N'1', N'2', N'link', N'', N'2022-02-18 00:01:40.0000000', N'2022-02-18 00:01:40.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'31', N'2', N'0,1,2', N'用户新增', N'4', N'', NULL, N'sys:user:add', N'1', N'1', N'', N'', N'2022-10-23 11:04:08.0000000', N'2022-10-23 11:04:11.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'32', N'2', N'0,1,2', N'用户编辑', N'4', N'', NULL, N'sys:user:edit', N'1', N'2', N'', N'', N'2022-10-23 11:04:08.0000000', N'2022-10-23 11:04:11.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'33', N'2', N'0,1,2', N'用户删除', N'4', N'', NULL, N'sys:user:delete', N'1', N'3', N'', N'', N'2022-10-23 11:04:08.0000000', N'2022-10-23 11:04:11.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'36', N'0', N'0', N'组件封装', N'2', N'/component', N'Layout', NULL, N'1', N'10', N'menu', N'', N'2022-10-31 09:18:44.0000000', N'2022-10-31 09:18:47.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'37', N'36', N'0,36', N'富文本编辑器', N'1', N'wang-editor', N'demo/wang-editor', NULL, N'1', N'1', N'', N'', NULL, NULL, NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'38', N'36', N'0,36', N'图片上传', N'1', N'upload', N'demo/upload', NULL, N'1', N'2', N'', N'', N'2022-11-20 23:16:30.0000000', N'2022-11-20 23:16:32.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'39', N'36', N'0,36', N'图标选择器', N'1', N'icon-selector', N'demo/icon-selector', NULL, N'1', N'3', N'', N'', N'2022-11-20 23:16:30.0000000', N'2022-11-20 23:16:32.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'40', N'0', N'0', N'接口', N'2', N'/api', N'Layout', NULL, N'1', N'7', N'api', N'', N'2022-02-17 22:51:20.0000000', N'2022-02-17 22:51:20.0000000', N'1', NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'41', N'40', N'0,40', N'接口文档', N'1', N'api-doc', N'demo/api-doc', NULL, N'1', N'1', N'api', N'', N'2022-02-17 22:51:20.0000000', N'2022-02-17 22:51:20.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'70', N'3', N'0,1,3', N'角色新增', N'4', N'', NULL, N'sys:role:add', N'1', N'1', N'', NULL, N'2023-05-20 23:39:09.0000000', N'2023-05-20 23:39:09.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'71', N'3', N'0,1,3', N'角色编辑', N'4', N'', NULL, N'sys:role:edit', N'1', N'2', N'', NULL, N'2023-05-20 23:40:31.0000000', N'2023-05-20 23:40:31.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'72', N'3', N'0,1,3', N'角色删除', N'4', N'', NULL, N'sys:role:delete', N'1', N'3', N'', NULL, N'2023-05-20 23:41:08.0000000', N'2023-05-20 23:41:08.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'73', N'4', N'0,1,4', N'菜单新增', N'4', N'', NULL, N'sys:menu:add', N'1', N'1', N'', NULL, N'2023-05-20 23:41:35.0000000', N'2023-05-20 23:41:35.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'74', N'4', N'0,1,4', N'菜单编辑', N'4', N'', NULL, N'sys:menu:edit', N'1', N'3', N'', NULL, N'2023-05-20 23:41:58.0000000', N'2023-05-20 23:41:58.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'75', N'4', N'0,1,4', N'菜单删除', N'4', N'', NULL, N'sys:menu:delete', N'1', N'3', N'', NULL, N'2023-05-20 23:44:18.0000000', N'2023-05-20 23:44:18.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'76', N'5', N'0,1,5', N'部门新增', N'4', N'', NULL, N'sys:dept:add', N'1', N'1', N'', NULL, N'2023-05-20 23:45:00.0000000', N'2023-05-20 23:45:00.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'77', N'5', N'0,1,5', N'部门编辑', N'4', N'', NULL, N'sys:dept:edit', N'1', N'2', N'', NULL, N'2023-05-20 23:46:16.0000000', N'2023-05-20 23:46:16.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'78', N'5', N'0,1,5', N'部门删除', N'4', N'', NULL, N'sys:dept:delete', N'1', N'3', N'', NULL, N'2023-05-20 23:46:36.0000000', N'2023-05-20 23:46:36.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'79', N'6', N'0,1,6', N'字典类型新增', N'4', N'', NULL, N'sys:dict_type:add', N'1', N'1', N'', NULL, N'2023-05-21 00:16:06.0000000', N'2023-05-21 00:16:06.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'81', N'6', N'0,1,6', N'字典类型编辑', N'4', N'', NULL, N'sys:dict_type:edit', N'1', N'2', N'', NULL, N'2023-05-21 00:27:37.0000000', N'2023-05-21 00:27:37.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'84', N'6', N'0,1,6', N'字典类型删除', N'4', N'', NULL, N'sys:dict_type:delete', N'1', N'3', N'', NULL, N'2023-05-21 00:29:39.0000000', N'2023-05-21 00:29:39.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'85', N'6', N'0,1,6', N'字典数据新增', N'4', N'', NULL, N'sys:dict:add', N'1', N'4', N'', NULL, N'2023-05-21 00:46:56.0000000', N'2023-05-21 00:47:06.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'86', N'6', N'0,1,6', N'字典数据编辑', N'4', N'', NULL, N'sys:dict:edit', N'1', N'5', N'', NULL, N'2023-05-21 00:47:36.0000000', N'2023-05-21 00:47:36.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'87', N'6', N'0,1,6', N'字典数据删除', N'4', N'', NULL, N'sys:dict:delete', N'1', N'6', N'', NULL, N'2023-05-21 00:48:10.0000000', N'2023-05-21 00:48:20.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'88', N'2', N'0,1,2', N'重置密码', N'4', N'', NULL, N'sys:user:reset_pwd', N'1', N'4', N'', NULL, N'2023-05-21 00:49:18.0000000', N'2023-05-21 00:49:18.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'89', N'0', N'0', N'功能演示', N'2', N'/function', N'Layout', NULL, N'1', N'11', N'menu', N'', N'2022-10-31 09:18:44.0000000', N'2022-10-31 09:18:47.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'90', N'89', N'0,89', N'Websocket', N'1', N'websocket', N'demo/websocket', NULL, N'1', N'3', N'', N'', N'2022-11-20 23:16:30.0000000', N'2022-11-20 23:16:32.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'91', N'89', N'0,89', N'敬请期待...', N'2', N'other', N'demo/other', NULL, N'1', N'4', N'', N'', N'2022-11-20 23:16:30.0000000', N'2022-11-20 23:16:32.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'93', N'36', N'0,36', N'签名', N'1', N'signature', N'demo/signature', NULL, N'1', N'6', N'', N'', N'2022-11-20 23:16:30.0000000', N'2022-11-20 23:16:32.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'94', N'36', N'0,36', N'表格', N'1', N'table', N'demo/table', NULL, N'1', N'7', N'', N'', N'2022-11-20 23:16:30.0000000', N'2022-11-20 23:16:32.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'95', N'36', N'0,36', N'字典组件', N'1', N'dict-demo', N'demo/dict', NULL, N'1', N'4', N'', N'', N'2022-11-20 23:16:30.0000000', N'2022-11-20 23:16:32.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'96', N'89', N'0,89', N'Permission', N'1', N'permission', N'demo/permission/page', NULL, N'1', N'1', N'', N'', N'2022-11-20 23:16:30.0000000', N'2022-11-20 23:16:32.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'97', N'89', N'0,89', N'Icons', N'1', N'icon-demo', N'demo/icons', NULL, N'1', N'2', N'', N'', N'2022-11-20 23:16:30.0000000', N'2022-11-20 23:16:32.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'98', N'0', N'0', N'Table', N'2', N'/table', N'Layout', NULL, N'0', N'10', N'table', N'', N'2023-08-08 20:49:50.0000000', N'2023-08-08 20:49:50.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'99', N'98', N'0,98', N'动态Table', N'1', N'dynamic-table', N'table/dynamic-table/index', NULL, N'0', N'1', N'', N'', N'2023-08-08 20:54:42.0000000', N'2023-08-08 20:54:42.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'100', N'98', N'0,98', N'拖拽Table', N'1', N'drag-table', N'table/drag-table', NULL, N'0', N'2', N'', N'', N'2023-08-08 20:54:42.0000000', N'2023-08-08 20:54:42.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'101', N'98', N'0,98', N'综合Table', N'1', N'complex-table', N'table/complex-table', NULL, N'0', N'3', N'', N'', N'2023-08-08 20:54:42.0000000', N'2023-08-08 20:54:42.0000000', NULL, N'1')
GO

INSERT INTO [dbo].[sys_menu] ([id], [parent_id], [tree_path], [name], [type], [path], [component], [perm], [visible], [sort], [icon], [redirect], [create_time], [update_time], [always_show], [keep_alive]) VALUES (N'102', N'26', N'0,26', N'平台文档(内嵌)', N'3', N'internal-doc', N'demo/internal-doc', NULL, N'1', N'1', N'document', N'', N'2022-02-18 00:01:40.0000000', N'2022-02-18 00:01:40.0000000', NULL, NULL)
GO

COMMIT
GO


-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_role]
GO

CREATE TABLE [dbo].[sys_role] (
  [id] bigint  NOT NULL,
  [name] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [code] nvarchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [sort] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [status] tinyint  NULL,
  [data_scope] tinyint  NULL,
  [deleted] tinyint  NOT NULL,
  [create_time] datetime2(7)  NULL,
  [create_userid] bigint  NULL,
  [create_username] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [update_time] datetime2(7)  NULL,
  [update_userid] bigint  NULL,
  [update_username] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_role] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色编码',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'code'
GO

EXEC sp_addextendedproperty
'MS_Description', N'显示顺序',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'sort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色状态(1-正常；0-停用)',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据权限(0-所有数据；1-部门及子部门数据；2-本部门数据；3-本人数据)',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'data_scope'
GO

EXEC sp_addextendedproperty
'MS_Description', N'逻辑删除标识(0-未删除；1-已删除)',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_role',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色表',
'SCHEMA', N'dbo',
'TABLE', N'sys_role'
GO


-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN TRANSACTION
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'1', N'超级管理员', N'ROOT', N'1', N'1', N'0', N'0', N'2021-05-21 14:56:51.0000000', NULL, NULL, N'2018-12-23 16:00:00.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'2', N'系统管理员', N'ADMIN', N'2', N'1', N'1', N'0', N'2021-03-25 12:39:54.0000000', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'3', N'访问游客', N'GUEST', N'3', N'1', N'2', N'0', N'2021-05-26 15:49:05.0000000', NULL, NULL, N'2019-05-05 16:00:00.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'4', N'系统管理员1', N'ADMIN1', N'2', N'1', N'1', N'0', N'2021-03-25 12:39:54.0000000', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'5', N'系统管理员2', N'ADMIN1', N'2', N'1', N'1', N'0', N'2021-03-25 12:39:54.0000000', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'6', N'系统管理员3', N'ADMIN1', N'2', N'1', N'1', N'0', N'2021-03-25 12:39:54.0000000', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'7', N'系统管理员4', N'ADMIN1', N'2', N'1', N'1', N'0', N'2021-03-25 12:39:54.0000000', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'8', N'系统管理员5', N'ADMIN1', N'2', N'1', N'1', N'0', N'2021-03-25 12:39:54.0000000', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'9', N'系统管理员6', N'ADMIN1', N'2', N'1', N'1', N'0', N'2021-03-25 12:39:54.0000000', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'10', N'系统管理员7', N'ADMIN1', N'2', N'1', N'1', N'0', N'2021-03-25 12:39:54.0000000', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'11', N'系统管理员8', N'ADMIN1', N'2', N'1', N'1', N'0', N'2021-03-25 12:39:54.0000000', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_role] ([id], [name], [code], [sort], [status], [data_scope], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'12', N'系统管理员9', N'ADMIN1', N'2', N'1', N'1', N'0', N'2021-03-25 12:39:54.0000000', NULL, NULL, NULL, NULL, NULL)
GO

COMMIT
GO


-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role_menu]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_role_menu]
GO

CREATE TABLE [dbo].[sys_role_menu] (
  [role_id] bigint  NOT NULL,
  [menu_id] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[sys_role_menu] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_role_menu',
'COLUMN', N'role_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_role_menu',
'COLUMN', N'menu_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色和菜单关联表',
'SCHEMA', N'dbo',
'TABLE', N'sys_role_menu'
GO


-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN TRANSACTION
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'2')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'3')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'4')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'5')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'6')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'11')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'12')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'19')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'18')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'17')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'13')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'14')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'15')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'16')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'9')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'10')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'37')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'20')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'21')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'22')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'23')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'24')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'32')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'33')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'39')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'34')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'26')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'30')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'31')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'36')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'38')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'39')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'40')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'41')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'2')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'3')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'4')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'5')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'6')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'20')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'21')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'22')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'23')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'24')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'26')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'30')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'31')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'32')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'33')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'36')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'37')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'38')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'39')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'40')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'41')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'70')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'71')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'72')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'73')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'74')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'75')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'76')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'77')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'78')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'79')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'81')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'84')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'85')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'86')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'87')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'88')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'89')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'90')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'91')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'92')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'93')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'94')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'95')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'96')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'97')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'102')
GO

COMMIT
GO


-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_user]
GO

CREATE TABLE [dbo].[sys_user] (
  [id] bigint  NOT NULL,
  [username] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [nickname] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [gender] tinyint  NULL,
  [password] nvarchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [dep_id] bigint  NULL,
  [avatar] nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [mobile] nvarchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [status] tinyint  NULL,
  [email] nvarchar(128) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [deleted] tinyint  NULL,
  [create_time] datetime2(7)  NULL,
  [create_userid] bigint  NULL,
  [create_username] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
  [update_time] datetime2(7)  NULL,
  [update_userid] bigint  NULL,
  [update_username] nvarchar(64) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_user] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户名',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'username'
GO

EXEC sp_addextendedproperty
'MS_Description', N'昵称',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'nickname'
GO

EXEC sp_addextendedproperty
'MS_Description', N'性别((1:男;2:女))',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'gender'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'password'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'dep_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户头像',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'avatar'
GO

EXEC sp_addextendedproperty
'MS_Description', N'联系方式',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'mobile'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户状态((1:正常;0:禁用))',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户邮箱',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'email'
GO

EXEC sp_addextendedproperty
'MS_Description', N'逻辑删除标识(0:未删除;1:已删除)',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建用户id',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'create_userid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建用户名',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'create_username'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新用户id',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'update_userid'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新用户名',
'SCHEMA', N'dbo',
'TABLE', N'sys_user',
'COLUMN', N'update_username'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户信息表',
'SCHEMA', N'dbo',
'TABLE', N'sys_user'
GO


-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN TRANSACTION
GO

INSERT INTO [dbo].[sys_user] ([id], [username], [nickname], [gender], [password], [dep_id], [avatar], [mobile], [status], [email], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'1', N'root', N'有来技术', N'0', N'$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', NULL, N'https://oss.youlai.tech/youlai-boot/2023/05/16/811270ef31f548af9cffc026dfc3777b.gif', N'17621590365', N'1', N'youlaitech@163.com', N'0', NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[sys_user] ([id], [username], [nickname], [gender], [password], [dep_id], [avatar], [mobile], [status], [email], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'2', N'admin', N'系统管理员', N'1', N'$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', N'1', N'https://oss.youlai.tech/youlai-boot/2023/05/16/811270ef31f548af9cffc026dfc3777b.gif', N'17621210366', N'1', N'', N'0', N'2019-10-10 13:41:22.0000000', NULL, NULL, N'2022-07-31 12:39:30.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_user] ([id], [username], [nickname], [gender], [password], [dep_id], [avatar], [mobile], [status], [email], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'3', N'test', N'测试小用户', N'1', N'$2a$10$xVWsNOhHrCxh5UbpCE7/HuJ.PAOKcYAqRxD2CO2nVnJS.IAXkr5aq', N'3', N'https://oss.youlai.tech/youlai-boot/2023/05/16/811270ef31f548af9cffc026dfc3777b.gif', N'17621210366', N'1', N'youlaitech@163.com', N'0', N'2021-06-05 01:31:29.0000000', NULL, NULL, N'2021-06-05 01:31:29.0000000', NULL, NULL)
GO

INSERT INTO [dbo].[sys_user] ([id], [username], [nickname], [gender], [password], [dep_id], [avatar], [mobile], [status], [email], [deleted], [create_time], [create_userid], [create_username], [update_time], [update_userid], [update_username]) VALUES (N'287', N'123', N'123', N'1', N'$2a$10$mVoBVqm1837huf7kcN0wS.GVYKEFv0arb7GvzfFXoTyqDlcRzT.6i', N'1', N'', NULL, N'1', NULL, N'1', N'2023-05-21 14:11:19.0000000', NULL, NULL, N'2023-05-21 14:11:25.0000000', NULL, NULL)
GO

COMMIT
GO


-- ----------------------------
-- Table structure for sys_user_out
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user_out]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_user_out]
GO

CREATE TABLE [dbo].[sys_user_out] (
  [id] bigint  NOT NULL,
  [userid] bigint  NOT NULL,
  [system_name] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [system_userid] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
  [system_username] nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[sys_user_out] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'其他系统用户对照表',
'SCHEMA', N'dbo',
'TABLE', N'sys_user_out'
GO


-- ----------------------------
-- Records of sys_user_out
-- ----------------------------
BEGIN TRANSACTION
GO

COMMIT
GO


-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user_role]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_user_role]
GO

CREATE TABLE [dbo].[sys_user_role] (
  [user_id] bigint  NOT NULL,
  [role_id] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[sys_user_role] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_user_role',
'COLUMN', N'user_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_user_role',
'COLUMN', N'role_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户和角色关联表',
'SCHEMA', N'dbo',
'TABLE', N'sys_user_role'
GO


-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN TRANSACTION
GO

INSERT INTO [dbo].[sys_user_role] ([user_id], [role_id]) VALUES (N'1', N'1')
GO

INSERT INTO [dbo].[sys_user_role] ([user_id], [role_id]) VALUES (N'2', N'2')
GO

INSERT INTO [dbo].[sys_user_role] ([user_id], [role_id]) VALUES (N'3', N'3')
GO

INSERT INTO [dbo].[sys_user_role] ([user_id], [role_id]) VALUES (N'287', N'2')
GO

COMMIT
GO


-- ----------------------------
-- Primary Key structure for table sys_dept
-- ----------------------------
ALTER TABLE [dbo].[sys_dept] ADD CONSTRAINT [PK__sys_dept__3213E83F68B0FF96] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_dict
-- ----------------------------
ALTER TABLE [dbo].[sys_dict] ADD CONSTRAINT [PK__sys_dict__3213E83F36B0BA3B] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table sys_dict_type
-- ----------------------------
CREATE UNIQUE NONCLUSTERED INDEX [type_code]
ON [dbo].[sys_dict_type] (
  [code] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table sys_dict_type
-- ----------------------------
ALTER TABLE [dbo].[sys_dict_type] ADD CONSTRAINT [PK__sys_dict__3213E83F99AAD64D] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table sys_employee
-- ----------------------------
CREATE UNIQUE NONCLUSTERED INDEX [login_name]
ON [dbo].[sys_employee] (
  [name] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table sys_employee
-- ----------------------------
ALTER TABLE [dbo].[sys_employee] ADD CONSTRAINT [PK__sys_empl__3213E83F2F6A86BB] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_menu
-- ----------------------------
ALTER TABLE [dbo].[sys_menu] ADD CONSTRAINT [PK__sys_menu__3213E83F63647FF0] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table sys_role
-- ----------------------------
CREATE UNIQUE NONCLUSTERED INDEX [name]
ON [dbo].[sys_role] (
  [name] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table sys_role
-- ----------------------------
ALTER TABLE [dbo].[sys_role] ADD CONSTRAINT [PK__sys_role__3213E83F0B20AD58] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table sys_user
-- ----------------------------
CREATE UNIQUE NONCLUSTERED INDEX [login_name]
ON [dbo].[sys_user] (
  [username] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table sys_user
-- ----------------------------
ALTER TABLE [dbo].[sys_user] ADD CONSTRAINT [PK__sys_user__3213E83F98DCBEE7] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table sys_user_out
-- ----------------------------
CREATE UNIQUE NONCLUSTERED INDEX [userid_system_name_system_userid]
ON [dbo].[sys_user_out] (
  [userid] ASC,
  [system_name] ASC,
  [system_userid] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table sys_user_out
-- ----------------------------
ALTER TABLE [dbo].[sys_user_out] ADD CONSTRAINT [PK__sys_user__3213E83F0C5ACBFF] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_user_role
-- ----------------------------
ALTER TABLE [dbo].[sys_user_role] ADD CONSTRAINT [PK__sys_user__6EDEA153DB2229A7] PRIMARY KEY CLUSTERED ([user_id], [role_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

